MICROSOFT EXCEL

Which of the following is an absolute cell reference?

• (A) !Α!Π
• (B) $A$1+
• (C) #a#1
• (D) Al

What symbol is used before a number to make it a label?

• (A) “(quote)
• (B) =(equal)
• (C) ‘(apostrophe)
• (D) (underscore)

Which symbol must all formula begin with?

• (A)=
• (B) (
• (C) +
• (D) @

Which of the following formulas is not entered correctly?

• (A) =10+50
• (B) B7 B1
• (C) =B7+14
• (D) 10+50

Which of the following formulas will Excel Not be able to calculate?

• (A) =SUM(Sales)-A3
• (B) =SUM(A1:A5)*.5
• (C) =SUM(A1:A5)/(10-10)
• (D) =SUM(A1:A5)-10

A typical worksheet has Number of columns:

• (A) 128
• (B) 256
• (C) 512
• (D) 1024

How many characters can be typed in a single cell in Excel?

• (A) 256
• (C) 32000
• (B) 1024
• (D) 65535

A worksheet can have a maximum of ________ Number of rows.

• (A) 256
• (B) 1024
• (C) 32000
• (D) 65535

Which of the following is not an example of a value?

• (A) 350
• (B) May 10, 2001
• (C) 0.57
• (D) Serial Number 50771

The chart wizard term data series refers to:

• (A) A chart legend
• (B) A collection of chart data markers
• (C) A set of values you plot in a chart
• (D) A data label