Microsoft Excel Microsoft Excel General 1

Question 1

Which symbol is used to make a cell reference absolute in Excel formulas?

Accepted Answer

$

Answer

@

Answer

#

Answer

&

Question 2

What keyboard shortcut saves an Excel workbook?

Accepted Answer

Ctrl+S

Answer

Ctrl+W

Answer

Ctrl+P

Answer

Ctrl+Z

Question 3

Which Excel function counts only cells that contain numerical values in a range?

Accepted Answer

COUNT

Answer

COUNTA

Answer

COUNTIF

Answer

SUM

Question 4

What is the maximum number of rows supported in a single Excel 2016 worksheet?

Accepted Answer

1,048,576

Answer

65,536

Answer

999,999

Answer

16,384

Question 5

Which Excel feature automatically applies colors or icons to cells based on their values?

Accepted Answer

Conditional Formatting

Answer

Data Validation

Answer

Format Painter

Answer

Cell Styles

Question 6

Which Excel view shows the spreadsheet exactly as it will look when printed, including headers, footers, and margins?

Accepted Answer

Page Layout View

Answer

Normal View

Answer

Page Break Preview

Answer

Full Screen View