Which one is not the correct method of editing a cell’s content:
- (A) Press the Alt key
- (B) Press the F2 key
- (C) Click the formula bar
- (D) Double click
- (A) Press the Alt key
In MS Excel, the command used to combine/merge the consecutively selected. cells and centre aligned is:
- (A) Combine & Center
- (B) Merge & Center
- (C) Merge Cells
- (D) Combine
- (B) Merge & Center
In MS Excel, the function to return one value if a condition is true and another value if it’s false is:
- (A) If function
- (B) Sum function
- (C) Decimal function
- (D) Info function
- (A) If function
The cell referencing that does not change
- (A) Absolute references
- (B) Comparative
- (C) Relative cell addressing
- (D) Reference
- (A) Absolute references
Which of the following function is used to get the correct data.
- (A) Exact()
- (B) Today()
- (C) Month()
- (D) Year()
- (B) Today()
To add two cells (A1 and A2) together in MS Excel,_____formula is used:
- (A) = A1+A2 Â
- (B) = Add(A1+A2)
- (C)= together(A1:A2)
- (D) A1 plus A2
- (A) = A1+A2 Â
An electronic spreadsheet is consist of:
- (A) Rows
- (B) Columns
- (C) Cells
- (D) All of these
- (D) All of these
Which one is the spreadsheet application that comes with MS Office software group:
- (A) MS Word
- (B) MS Excel
- (C) MS PowerPoint
- (D) MS Access
- (B) MS Excel
Microsoft Excel functions arguments are always written in:
- (A) Cells
- (B) Rows
- (C) Columns
- (D) Parentheses
- (D) Parentheses
The options. Portrait and Landscape come under.
- (A) Paper size
- (B) Page Orientation
- (C) Page Layout
- (D) Page Row
- (B) Page Orientation