WorksheetsMicrosoft Excels: Formulas and Functions
Total questions: 45
Worksheet time: 15mins
The command used for reading the table for a particular row is?
IF
VLOOKUP
HLOOKUP
SUM
If we write the formula = 8 + 5 * 3 in Ms Excel, the result is?...
39
29
23
43
The portion of Microsoft Excel that is used as the screen scroll button is..
Ribbon
Tab Menu
Scroll
Formula Bar
Ordering data in Ms. Excel from small to large is called...
Ascending
Descending
Fescending
Sescending
The command used to set the column width is ...
Row height
Column width
Insert row
Insert column
The document file management button on the Office Excel Microsof is round in shape with the Office logo in the middle called.… office button
Excel Options
Office Button
Ribbon
Tittle Bar
Toolbar
To change the unit of measure in Excel, use the command….
Start–Setting–Control Panel–Regional–Currency
Tools–Options–Print
Office Button–Open
Office Button–Excel Options–Save–Default File Location
Office Button–Excel Options–Advanced–Display–Ruler Units
To move or copy a worksheet, the menu that should be selected after right-clicking on the sheet tab is….
Delete
Rename
Select all sheet
Move or Copy
Paste
The menu that should be selected to widen or narrow the column size on the worksheet is...
Insert Sheet Column
Insert Sheet
Borders
Row Height
Column Width
To add a line in Excel, the command that is clicked on the Insert menu is….
Insert Cells
Insert Sheet Rows
Insert Sheet Column
Insert Sheet
Insert Name
An area on the worksheet that is rectangular and where a collection of cells is called….
Sheet
Column
Range
Pointer
Gridline
The document file management button on the Office Excel Microsof is round in shape with the Office logo in the middle called.…
Excel Options
Office Button
Ribbon
Tittle Bar
Toolbar
One way to save a wordbook in Excel is to use….
Ctrl + B
Ctrl + P
Ctrl + C
Ctrl + V
Ctrl + S
The following is the cell address, namely ...
84
3F
B5
BB
F0
The “save”, “redo”, and “undo” icons are part of the menu of….
Ribbon
Office Button
Status Bar
Quick Access Toolbar
Titlebar
The menu that should be selected to adjust the column size by narrowing and width on the worksheet is….
Insert Sheet Column
Insert Sheet
Borders
Row Height
Column Width
Following buttons are used in formatting text to be italic, is…
Ctrl + B
Ctrl + I
Ctrl + U
Ctrl + S
Ctrl + O
To add lines in Excel, the command on the Insert menu is….
Insert Cells
Insert Sheet Rows
Insert Sheet Column
Insert Sheet
Insert Name
To end Excel, press the button:
Alt + F4
Ctrl + F4
Alt + F2
Ctrl + F2
Alt + F5
Calculate the average of numerical data using the following functions:
AVERAGE
MIN
MAX
SUM
VLOOKUP
Below that are not included in statistical functions are...
= sum ()
= count ()
= min ()
= if ()
= Max ()
To combine two or more text strings into one text string is a function of:
LEFT
RIGHT
CONCATENATE
LEN
SUBSTITUTE
To round a number to the nearest value based on a specific number or its desired multiple. Is a function of:
MROUND
CEILING
ROUND
ROUND DOWN
ROUND UP
The formula to finding the price using VLOOKUP is :
(LEFT (A3; 6); A11: B16;
2; FALSE)
(RIGHT (A3; 3); A20: D21;
2; FALSE)
IF (ISERROR (VLOOKUP (LEFT
(A8; 6); A16: B21; 2; FALSE)); 0; ISERROR (VLOOKUP (LEFT (A8; 6); A16:
B21; 2; FALSE)))
IFERROR (HLOOKUP (RIGHT (A8; 3); $ A $ 20: $ D $ 21; 2; FALS E); "None")
D3 = IF (AND (B3 =
"LED TV"; C3 = "50 inch"); "Expensive";
"Medium")
One way to save a wordbook in Excel is to use the keyboard button….
Ctrl + B
Ctrl + P
Ctrl + C
Ctrl + V
Ctrl + S
The following is which cell address:
84
B5
3F
F0
BB
The "save", "redo", and "undo" icons are part of the menu in Microsoft Excel, are….
Ribbon
Office Button
Status Bar
Quick Access Toolbar
Titlebar
To combine cells contained in a formula is called ...
Reference operator
Comparison operator
Mathematical operators
Addition operator
The function that is used to find the lowest value of a set of data is called a function ...
Max function
Min function
Averange function
Product function
Choosing between 2 or more possibilities of the given logical comparisons is called a function
IF function
AND function
HLOOKUP function (X, Y, Z)
VLOOKUP function (X, Y, Z)
Spreadsheet-based programs in the product of Microsoft Office are...
Ms. Power Point
Ms. Word
Ms. Excel
Ms. Access
The place to put the values on the excel worksheet is called:
Cell
Row
Column
Bit
A website we evaluate, it turns out that we need that an object needs to link to a page on another site, so that the unser gets clarity when it comes to linking to other pages / sites. At this stage, it is used:
Hypertext Markup
Link to web
Hyperlink
URL link
How to merge both cells on excel worksheet?
Merge Cells
Delete Cells
Copy Cells
Move Cells
Which includes the formula for the correct IF writing is...
=IF (Comparison; Value if true; Value if false)
= IF (Comparison: Value if true: Value if false)
= IF (Comparison, Value if true: Value if false)
= IF [Comparison; Value if true; Value if false]
The part of the excel window that functions to display the address of the currently active cell is
Formula Bar
Name Bar
Status Bar
Title Bar
Total number of lines in Ms. Excel 2003…
65,535
65,536
65,636
66,535
The following which cannot be used to run excel are
Excel shortcuts on the desktop
Start menu
Excel file
Word document
To end Excel, press the button:
Alt + F4
Ctrl + F4
Alt + F2
Ctrl + F2
Calculate the average of numerical data using the following functions:
AVERAGE
MIN
MAX
SUM
Setting the rupiah sign for data in the form of money is done in the dialog box
Options
Cells Format
Page Setup
Microsoft Excel is an application program
Spreadsheet
Wordprocessor
Presentation
Animations
The function used to calculate the average of numerical data
SUM
MAX
MIN
AVERAGE
To adjust the table row height using the command
Format, wide, height
Format, row, height
Format, coloum, autoselection
Format, row, autoselection
The right way to activate ms-excel is ...
Start - programs - ms office - ms word
Ms excel - start - programs - ms office
Program - MS Excel - Start - MS Office
Start - program - ms office - ms excel
