This Set of Questions are for Target Audience already aware of Basic Excel Concepts. Questions : 20Time Limit : 40 minsPass Criteria : 60 %
=IF(LOGICAL TEST,TRUE RESULT,FALSE RESULT)
=IF(LOGICAL TEST,FALSE RESULT,TRUE RESULT)
=IF(LOGICAL TEST,TRUE RESULT)(LOGICAL TEST, FALSE RESULT)
ALL OF THE ABOVE
Apply special attributes using Format Painter
Apply an Auto Format Style
Apply a selected background color
All of above
B1:G10
B1-G10
B1;G10
B1&G10
A default chart
A 2-dimensional column chart
A 2-dimensional bar chart
A 3-dimensional line chart
=A1+A2
=Add(A1+A2)
=together(A1:A2)
A1 plus A2
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the Word button on the taskbar while pressing Shift key
By displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key
A and c
Average
Count
Sum
Table
Category axis
Data marker
Data point
Gridline
Multiplication and division, exponential positive and negative value
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
None of above
Workday
Date
Networkdays
All of the above
Use Ctrl to select all three cells, then click the paste button on the standard toolbar
Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
All of above
The group button on the standard toolbar
The shift key and the mouse
The ctrl key and mouse
The alt+enter key
Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of above
Spreadsheet program
Database program
Word processor program
Desktop publisher program
With the copy, paste and cut commands
With commands on a shortcut
With buttons on the Qucik access toolbar
All of the above
Compares the content in two cells
Counts the numbers of characters in a cell
Deletes extra space in text
All of above
CTRL + A
CTRL + PGUP
CTRL + PGDOWN
CTRL + HOME
Cell address
Constant
Function
Range
The print density of characters
The height of the printed character
Upright or slanted shape
The design and appearance of characters
True
False
Wait!
Here's an interesting quiz for you.