A. Format number in comma format
B. Format number in currency format
C. Format number in date format
D. Format number in time format
View Answer
ANSWER: A) Format number in comma format
Explanation : Ctrl+Shift+1 shortcut Key in excel is used to format number in comma format
Explanation : Ctrl+Shift+1 shortcut Key in excel is used to format number in comma format
A. Ctrl+4
B. Ctrl+5
C. Ctrl+6
D. None of the above.
View Answer
ANSWER: B) Ctrl+5
Explanation : CTRL+5 used to strikethrough highlighted selection in Excel?
Explanation : CTRL+5 used to strikethrough highlighted selection in Excel?
A. Column
B. Value
C. Address
D. Cell
View Answer
ANSWER: D) Cell
Explanation : Intersection of Row and column in MS Excel is called cell. Cell is a basic building block in MS Excel Worksheet and used to enter data.
Explanation : Intersection of Row and column in MS Excel is called cell. Cell is a basic building block in MS Excel Worksheet and used to enter data.
A. Pie Chart
B. Column Chart
C. Line Chart
D. Dot Graph
View Answer
ANSWER: B) Column Chart
Explanation : Column Chart is useful for comparing values over categories.
Explanation : Column Chart is useful for comparing values over categories.
A. NUM
B. COUNT
C. SUM
D. CHKNUM
View Answer
ANSWER: B) COUNT
Explanation : COUNT function in Excel tells how many numeric entries are there.
Explanation : COUNT function in Excel tells how many numeric entries are there.
A. Formula
B. Sorting
C. Filtering
D. Pivot
View Answer
ANSWER: C) Filtering
Explanation : Filtering is the feature that displays only the data in column(s) according to specified criteria.
Explanation : Filtering is the feature that displays only the data in column(s) according to specified criteria.
A. Adobe Photoshop
B. Excel
C. Notepad
D. Power Point
View Answer
ANSWER: B) Excel
Explanation : Statistical calculations and preparation of tables and graphs can be done by using MS Excel.
Explanation : Statistical calculations and preparation of tables and graphs can be done by using MS Excel.
A. Column Chart
B. Bar Chart
C. Pie Chart
D. Dot Chart
View Answer
ANSWER: B) Bar Chart
Explanation : For comparisons, bar charts are useful. Bar graphs are used to compare two groupings of data or to follow changes over time. So, Bar charts can be used to compare the performance of two employees in the year 2016
Explanation : For comparisons, bar charts are useful. Bar graphs are used to compare two groupings of data or to follow changes over time. So, Bar charts can be used to compare the performance of two employees in the year 2016
A. SUM
B. AVG
C. MAX
D. MIN
View Answer
ANSWER: B) AVG
Explanation : AVG is not a funcation in MS Excel Rather it is used in SQL. MS Excel provides AVERAGE() function to calculate average of a set of values.
Explanation : AVG is not a funcation in MS Excel Rather it is used in SQL. MS Excel provides AVERAGE() function to calculate average of a set of values.
A. () sign
B. Equal Sign
C. Plus Sign
D. > Sign
View Answer
ANSWER: B) Equal Sign
Explanation : Functions and formulas in MS Excel must begin with equal ( = ) Sign
Explanation : Functions and formulas in MS Excel must begin with equal ( = ) Sign