Electronic Spreadsheet

note!Answer: C) Column F row 5
Cell labels give the column letter first, then the row number, so F5 is column F, row 5.

note!Answer: A) Sheet1/Sheet2/Sheet3
Excel's default sheets are named Sheet1, Sheet2, and Sheet3 in that order.

note!Answer: D) Mod()
MOD(number, divisor) returns the remainder after division.

note!Answer: D) PMT
Sum, Average, and Count are consolidation functions; PMT is a financial function for loan payments.

note!Answer: B) A1
A valid cell address combines a column letter with a row number, such as A1.

note!Answer: A) Equal sign
Every Excel formula begins with an equal sign (=).

note!Answer: C) =sum(A1:A2)
SUM is a valid Excel function, and it is written with an equal sign and a range.

note!Answer: A) Upper ("Nepal")
UPPER() converts text to all capital letters.

note!Answer: C) Ltrim()
LTRIM removes leading spaces from the left side of text, while RTRIM removes trailing spaces.

note!Answer: D) =SUM(A1,A2)
=SUM(A1,A2) uses correct syntax; the other options have wrong ranges or are missing functions.

note!Answer: D) Join reference
Excel's cell reference types are relative, absolute, and mixed; 'join reference' is not one of them.

note!Answer: A) Workbook
An Excel file is called a workbook, and it contains one or more worksheets.

note!Answer: A) X-axis
In a chart, category labels are placed on the horizontal X-axis, and values are on the Y-axis.

note!Answer: A) Display the records that meet the criteria
A filter shows only the rows that match the given criteria and hides the rest.

note!Answer: B) $
The $ sign creates absolute references, which lock a row or column such as $A$1 or $A1.

note!Answer: A) =
In Excel, every formula starts with an equals sign (=).

note!Answer: B) Data menu
The Filter command is found in the Data menu (Data tab in newer versions).

note!Answer: C) Right side
Inserting a column pushes the existing columns to the right.

note!Answer: A) Row and column
A table is made up of rows and columns.

note!Answer: A) Formula bar
The formula bar shows the content or formula of the active cell.