WorksheetsQuiz U.3 Excel Eng. 1/64
Total questions: 20
Worksheet time: 13mins
Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below. How do you change column width to fit the contents?
Single-click the boundary to the left of the column heading
Double-click the boundary to the right of the column heading
Change the font format in the cellChange the font format in the cell Double-click the boundary to the right of the column heading
all incorrect
These are known as
workbooks
worksheets
formula bar
cell
A formula in the spreadsheet should always start with
a plus sign
an asterisk
an equals sign
a capital letter
Which of these would add up the numbers from A3 to A6
+(A3:A6)
=(A3:A6)
=(Ave(a3:a6))
=Sum(A3:A6)
Cell C1 contains the formula =A1+B1. If you copy the formula in C1 to cell C2, which of the following formulas will appear in cell C2?
=A1+B1
=C1+C2
=A2+B2
=A2+B2
For which calculations is the IF function used?
used for automatic calculations
used for conditional calculations
Used for calculating cases where the cell group analyzed by the program is invalid.
used for calculating numbers or cell references.
What is the formula for E2 position?
=(c3*100)/$C$5
=(c3/100)*$C$5
=(c3*$C$5)/100
=(c3/$C$5)*100
The formula for calculating the circled cell, which of the following is correct?
=10*15
=C2+D2
C2*A2=
=C2*D2
Which of the following uses the wrong calculation formula?
=average(a1:a10)
=sum(a1+a10)
=if(a1>10,"0","1")
=max(a1:a10)
Which formula is correct?
=if(C3<80,"A")
=if(C2>80,"A")
=if(C2<=80,"A")
=if(C2>=80,"A")
What is the formula for E5 position?
IF(D5>=5000,D5*10%,0)
IF(D5<=5000,D5*10%,0)
IF(D5>=5000,D5*10%)
ไม่มีข้อใดถูก
What formula should F3 be used for?
=VLOOKUP(F3,B2:C8,1,FALSE)
=VLOOKUP(F3,B2:C8,1,FALSE)
=VLOOKUP(F3,B2:C8,2,FALSE)
=VLOOKUP(F3,B2:C8,2,FALSE)
What formula should B7 be used for?
=MIN(B1:E1)
=MAX(B1:E1)
=SMALL(B1:E1)
=LARGE(B1:E1)
What formula should B5 be used for?
=COUNT(B1:E1)
=COUN(B1:E1)
=CUONT(B1:E1)
=COUTN(B1:E1)
What is the function of Vlookup ?
Summarizes a large amount of data in the form of a table and graph patterns
Automate tasks in Excel
Creating a graph in a spider chart (Radar/Spider chart)
Find and reference information
Cell Range
combines multiple lines into on cell
A combination of numbers and symbols used to express a calculation
to copy a cell’s contents and formatting into other cells
a block of cells that can be selected (B4:B16)
The function COUNT is specific for _________________
Counting cells
Counting text
Counting number
Counting tables
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
Insert
Formula bar
Tables
cell address
How do you select an entire column?
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column.
Hold down the Ctrl key as you click anywhere in the column
Which formula gets the biggest value of a range of cells?
MAX
MIN
LARGE
SUM
