WorksheetsQuiz on Excel-III
Total questions: 10
Worksheet time: 5mins
In MS-Excel to move to the previous worksheet
Alt + PgUp
Ctrl + PgUp
Ctrl + PgDn
Shift + Tab
In MS-Excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Press Home
Press Shift + Home
Press Ctrl + Home
It's not possible
In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
Workday
Date
Networkday
Weekday
What is the shortcut key to insert new sheet in current workbook?
Alt + F11
Ctrl + F11
Shift + F11
None of these
Which of the following formulas will Excel Not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
You can display all formulas in an active worksheet by pressing the _____ keys
Alt +`
Ctrl +`
Ctrl+W
Ctrl+¬
What is the correct way to refer the cell A10 on sheet3 from sheet1?
sheet3!A10
sheet1!A10
Sheet3.A10
A10
What does COUNTA () function do?
counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
What does the LEN() function do?
Deletes Trailing spaces
Splits the Cell contents
Counts the number of characters in a cell
ll of the choices
Cell A5 shows a figure of 645123.875. Which of the following functions will display result 645123.9?
Round(A5,-3)
Round(A5,-2)
Round(A5,-1)
Round(A5,1)
