MCQs
6530 questions found
A.
To create full-sized charts on a separate sheet.
✓
B.
To insert small charts within a single cell to represent data trends.
✓
C.
To apply conditional formatting.
✓
D.
To animate cell values.
✓
A.
SheetName!CellAddress
✓
B.
SheetName.CellAddress
✓
C.
CellAddress@SheetName
✓
D.
CellAddress(SheetName)
✓
A.
To find the maximum value in a range.
✓
B.
To determine what input value is needed to achieve a desired output (goal).
✓
C.
To highlight cells with specific values.
✓
D.
To predict future trends.
✓
A.
Moves one screen up in the current worksheet.
✓
B.
Moves to the previous worksheet in the workbook.
✓
C.
Moves to the previous workbook.
✓
D.
Scrolls to the top of the current worksheet.
✓
A.
Moves one screen down in the current worksheet.
✓
B.
Moves to the next worksheet in the workbook.
✓
C.
Moves to the next workbook.
✓
D.
Scrolls to the bottom of the current worksheet.
✓
A.
To create simple calculations.
✓
B.
To summarize and analyze large datasets.
✓
C.
To draw complex shapes.
✓
D.
To check for spelling errors.
✓
A.
Looks for a value in the leftmost column of a table, and returns a value in the same row from a column you specify.
✓
B.
Looks for a value in the top row of a table, and returns a value in the same column from a row you specify.
✓
C.
Adds values vertically.
✓
D.
Validates data entry.
✓
C.
Ctrl + Shift + + (plus)
✓
D.
Ctrl + Shift + - (minus)
✓
C.
Ctrl + Shift + + (plus)
✓
D.
Ctrl + Shift + - (minus)
✓
