What Does this Excel Formula Do? =IF(E6=G6;"Nice";"Not so Nice")



Download 253.19 Kb.
Page1/4
Date16.06.2018
Size253.19 Kb.
#52309
  1   2   3   4

1.

What Does this Excel Formula Do? =IF(E6=G6;"Nice";"Not so Nice")


A. *

Checks if E6 equals G6 and if it does, the result is true and the formula returns 'Nice'


B.

Sums up the range E6 to G6 and if the sum is greater than zero then, the formula returns 'Nice'


C.

Creates borders around cell G6


D.

It changes your font color to Red


E.

Right answer not shown


2.

What Does this Excel Formula Do? =NOW()


A.

NOW stands for, Notes On Workbook and adds a comment to the active cell


B.

It returns information on the properties of the workbook you are working with


C. *

It returns the current date and time


D.

It tells you when it is time to go home from work


E.

It returns the current date only


3.

What Does this Excel Formula Do? =MAX(G4:G9)


A.

Sorts the values within the range in ascending order


B. *

Returns the highest value within the range of cells


C.

Change letters from lower-case to upper-case within the range of cells


D.

Sorts the values within the range in descending order


E.

Returns the lowest value within the range of cells


4.

What is the correct syntax for typing a function into a cell in the Excel ?


A. *

Equals sign, function name, matching brackets, arguments


B.

Equals sign, function name, result


C.

Function name, argument, equals sign


D.

Function name, equals sign, argument


E.

Equals sign, arguments, function name


5.

Which excel function calculates the largest value in a set of numbers?


A.

Average


B.

Count


C.

Min


D. *

Max


E.

Var


6.

What Does this Excel Formula Do? =IF(ISBLANK(G5)=TRUE;(IF(ISERROR(J5-J6)=TRUE;"Error!";(J5-J6)));G5)


A.

The formula verifies that cell G5 is blank and if it is not, it returns the result of cells J5-J6


B.

The formula checks if G5 is blank and if it is, it returns the value of cell G5


C.

The formula checks the result of J5-J6 and if it is in error (non-numeric) it returns the value of G5


D. *

The formula checks if G5 is blank and if it is, it returns the result of cells J5-J6 if it is numeric. Otherwise it will return “Error!”


E.

The formula checks if G5 is blank and if it is, it returns the value of cells J5-J6


7.

In an Excel IF function, the arguments required are _____.


A. *

the logical test itself, value if test is true, value if test is false


B.

the logical test itself, three possible values


C.

the logical test itself, value if test is true, value if test is false, formatting you want to use when the test is true


D.

the logical test itself, value if test is true, value if test is false, initial value


E.

the logical test itself, default value, value if test is false


8.

Which of the following IF functions is correctly written?


A.

IF(C4>=D4,C4,"Too small")


B.

IF(C4>=D4;C4,Too small)


C. *

=IF(C4>=D4,C4,"Too small")


D.

=IF(C4>=D4;C4;"Too small")


E.

=IF(C4>=D4,C4,Too small)


9.

An Excel. A sheet has the following named cells: B3 is named Current, C3 is named Last Month, D3 is named Average for Year. Which formula below calculates the difference between the current value and last month's value?


A. *

=Current - Last Month


B.

Current - Last Month


C.

=B3(Current) - D3(Last Month)


D.

=(Current + Last Month) /2


E.

=B3*(Current) - D3*(Last Month)


10.

An Excel formula must always start with a(n) ____________ .


A.

Astrisk


B.

Quotation Mark


C.

Period


D. *

Equal Sign


E.

Colon


11.

Except for the __________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result.


A. *

IF


B.

AND


C.

OR


D.

NOT


E.

Right answer not shown


12.

What would be the result of this formula, entered into a cell in Excel? =10+2*5


A.

100


B.

60


C.

25


D. *

20


E.

52


13.

Which menu command would you use to change the margins for printing in Ms Excel


A.

File -> PrintPreview


B.

File -> Print


C.

Format -> Margins


D. *

File -> Page Setup


E.

Format -> Printing


14.

To create a Excel chart, you will typically perform a number of steps that are called Chart Wizard. Show properly order of it:
1. Select the chart data on the worksheet
2. Choose where to put the new chart
3. Choose a Chart Type
4. Click the Chart Wizard button
5. Setup Chart ans Axis titles


A. *

1, 4, 3, 5, 2


B.

3, 5, 2, 4, 1


C.

2, 5, 3, 1, 4


D.

4, 3, 1, 5, 2


E.

1, 2, 3, 4, 5


15.

What would be the result of this formula, entered into a cell in Excel?
=3+2*4


A.

Error message will be displayed


B.

14


C. *

11


D.

9


E.

20


16.

Which key on the keyboard can you use to add the $ signs to Excel cell reference in order to make it an absolute reference?


A.

F3


B.

F2


C.

F5


D. *

F4


E.

F6


17.

Which of the following date will be automatically recognized as a date when entered into a cell independently to the Windows Regional Settings?


A. *

3/01/2003


B.

3 January 2003


C.

3-Jan-2003


D.

3rd January 2003


E.

Jan03 2003


18.

Which command would you use to save an existing Excel workbook into a Lotus 1-2-3 compatible file or into a other file formats?


A.

File –> Properties


B.

You can not save an Excel workbook into any other format


C. *

File -> Save As


D.

File –> Export


E.

File –> Save


19.

To include an Excel sheet table in a Word document that will show the most recent version of the data, use _____ .


A.

right answer not present


B.

convert Excel sheet into the Word table


C.

a picture object


D. *

an linked object


E.

an embedded object


20.

Which of the following Excel IF functions is correctly written?


A.

=IF(C4>=D4,C4,Too small)


B.

=IF(C4>=D4;C4;"Too small")


C. *

=IF(C4>=D4,C4,"Too small")


D.

IF(C4>=D4;C4,Too small)


E.

IF(C4>=D4,C4,"Too small")


21.

In an IF function Ms Excel, the arguments required are _____.


A.

the logical test itself, default value, value if test is false


B.

the logical test itself, value if test is true, value if test is false, initial value


C.

the logical test itself, value if test is true, value if test is false, formatting you want to use when the test is true


D.

the logical test itself, three possible values


E. *

the logical test itself, value if test is true, value if test is false


22.

You have a Excel table that uses rows 3 , 4, and 5 for data, leaves row 6 blank, and has formulas in row 7 that add up the cells in the column above. The formulas include the blank row 6. Which rows can you select to insert a new row and the new cells WILL be included in the formulas?


A.

3 or 4 or 6


B.

4 and 5 only


C.

3, 4, 5, or 6


D. *

4, 5, 6, or 7


E.

3, 4, 5, 6, or 7


23.

To insert an AutoShape in the Excel worksheet, you would use the _____ .


A.

All methods are right


B.

AutoShapes button on the Insert bar


C.

AutoShapes button on the Formatting bar


D. *

AutoShapes button on the Drawing bar


E.

Menu command “Insert -> AutoShape”


24.

To clear just the formats from a selection you can _____.


A.

Right answer not present


B.

Choose Format -> AutoFormat… - select format None.


C.

Right click on the selection and choose Clear… -> Formats


D.

Use the key combo CTRL + f


E. *

Choose from the menu: “Edit -> Clear… -> Formats” or “Format -> AutoFormat…” - select format “None”


25.

The styles available in the Excel Style Box _____.


A.

include formula and cell styles only


B.

can be created only using the Style dialog on the Format menu


C.

include paragraph and cell styles only


D. *

include only cell styles


E.

include paragraph, character, and cell styles.


26.

In Excel if you drag a selection on top of cells that have data, what happens next is that _____.


A.

data will be replaced with zeros


B.

you are told that you cannot do that since the cells are not empty


C. *

you are asked if you want to replace the data


D.

the old data is moved down and to the right so it is out of the way


E.

the old data is overwritten with what you dragged


27.

To copy just the formatting of a range you would use _____


A.

Paste Special -> Object


B.

Paste Special -> Paste Link


C. *

Paste Special -> Formats


D.

Format Painter


E.

CTRL + Copy


28.

If your Excel sheet is too wide to print on one sheet, to make it fit on one page you can try _____.


A. *

all listed answers are right


B.

change the orientation


C.

use the “Fit to…” setting in the “Scaling” section of “Page Setup”


D.

make the margins smaller


E.

make the column widths smaller


29.

Once you have created a chart in MS Exul you may change _____.


A.

only the chart placing options


B.

the text formatting and the data series patterns only


C. *

everything about the chart


D.

only by going back through the Chart Wizard


E.

only the formatting for text like titles and data labels


30.

In Excell to access the dialog to customize a toolbar you would _____.


A.

Click button with two down arrow that are located at end of the each toolbars (Office version above XP)


B. *

all listed answers are right


C.

right-click any toolbar and choose “Customize” from the popup menu


D.

select from the menu Tools -> Customize…


E.

double-click the toolbar you want to edit


31.

The default orientation for the printed page is _____.


A.

horizontal


B.

vertical


C.

whatever was last used


D.

landscape


E. *

portrait


32.

Excel. To remove the contents of several cells at once, you can _____.


A.

select the cells and press BACKSPACE and ENTER keys.


B. *

all listed answers are right


C.

select the cells and drag the fill handle back up over them


D.

select the cells and choose Edit -> Clear... -> Contents


E.

select the cells and press DELETE.


33.

To print just part of a sheet, you would select what you want to print and _____


A.

click the PrintPreview button


B. *

select “Print” selection in the “Print” dialog and then print


C.

select “Print” selection on Page Setup -> Sheet and then print


D.

press the PRINT SCREEN key


E.

click the Print button


34.

If you select a cell with a date in it and drag the fill handle down across several cells, what happens is that _____.


A.

the date is increased by 1 year into each cell


B.

nothing as AutoFill applies only to numbers


C.

the date is increased by 1 week into each cell


D. *

the date is increased by 1 day into each cell


E.

the date is copied to each cell


35.

In Ms Excel a logical test can use which of the following operators? = < > <>


A.

= and <


B.

Nothing


C. *

All four


D.

< and > and <>


E.

= and < and >


36.

MS Excel. You select several cells which contain numbers. AutoCalculate shows the value that it calculates with these numbers in


A.

the Address cell


B.

the Formula bar


C. *

the Status bar


D.

the upper left selected cell


E.

a popup tip


37.

In Excell Sheet2 is a copy of Sheet1. You change some of the values on Sheet1. The values on Sheet2


A.

change to zero


B.

are replaced with the error value #VALUE!


C.

are replaced with error value #REF!


D.

change to match the new values on Sheet1


E. *

do not change to match


38.

Your sheet has an image that covers cells A1, A2, B1, and B2. You select cell A1, cut it and paste to cell F1. The image


A.

it will be deleted


B.

is deleted from A1 but not pasted to F1


C.

is pasted but is sized to fit inside cell F1


D.

is pasted also to F1


E. *

will be do not changed - image layer is separated from cells layer


39.

If a cell shows #######, it means that


A.

your formula has a division by zero


B.

all listed answers are right


C. *

the column is too narrow to show all the digits of the number


D.

the row is too short to show the number at the current font size


E.

your formula has a syntax error


40.

The Excel formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is


A.

=D4+C2*B2


B.

=(B2*(D4+C2)


C. *

=(D4+C2)*B2


D.

D4+C2*B2


E.

(D4+C2)*B2)


41.

In Ms Excel to arrange rows in alphabetical order based on column A, you need to use the menu command


A.

File -> PageSetup


B.

Right answer not present


C.

Edit -> Data - Sort


D. *

Data -> Sort


E.

Tools -> Sort


42.

Using the Excel AutoSum button will place in the selected cell


A.

the multiple of values in the cell's column


B. *

a formula which will add values in the range Excel guesses you want to add


C.

the sum of the cell's row unless you change the range


D.

nothing until you select a range of cells


E.

the sum of values in the cell's column


43.

In Excel to select several cells or ranges that are not touching each other, you would _____ while selecting.


A.

hold down ALT + SHIFT


B.

hold down CTRL + SHIFT


C.

hold down the ALT key


D.

hold down the SHIFT key


E. *

hold down the CTRL key


44.

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is


A.

B1=G10


B. *

B1:G10


C.

B1;G10


D.

B1.G10


E.

B1-G10


45.

To select a column the easiest method is to


A.

click the empty button on intersection of column headings and row labels


B.

click the Formula Bar


C. *

click the column heading


D.

drag from the top cell in the column to the last cell in the column


E.

double-click any cell in the column


46.

If a Excel cell shows #####, it means that


A.

All listed answers are right


B.

you tried to divide by zero


C.

Excel does not understand your formula


D.

the row is too short to show all of the number


E. *

the column is too narrow to show all of the number


47.

In Ms Excel formula in cell E6 refers to cell A6. Cells A4, A5, and A6 are then merged. The formula in cell E6 will now


A.

show the error value #VALUE!


B. *

use a zero in place of A6


C.

show the error value #REF!


D.

use the original value in A6.


E.

use the value in the merged cell A4


48.

The range C4:F10 contains a table. Column F contains formulas that add the values in the row. You move the range C4:D10 left two columns, but leave the cells in column F in place. The formulas in column F


A.

are replaced with the zero value.


B.

are replaced with the error value #VALUE!


C. *

are automatically changed to use the cell references for the new location of the table cells


D.

are replaced with the error value #REF!


E.

still refer to the original cells


49.

In Excel the settings to wrap text in a cell and to merge cells are found in the Format Cells dialog on the _____ tab.


A.

View


B.

Border


C.

Font


D. *

Alignment


E.

Number


50.

In Excel Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are


A.

4, 6, 8


B. *

6, 8, 10


C.

2, 2, 2


D.

2, 4, 2


E.

8, 16, 32


51.

To edit existing data in a cell without having to retype it all, you should


A.

hold ALT down while clicking the cell


B.

none of the listed methods - you must retype


C.

hold SHIFT down while clicking the cell


D. *

double-click the cell


E.

click in the Formula bar


52.

The default currency and the units used in measurement are set in


A.

File -> Print


B.

Tools -> User Settings


C.

Tools -> Options


D.

File -> Page Setup


E. *

Regional Settings or Regional and Language Options


53.

Excel AutoCalculate will quickly add selected cells if you


A.

right-click on the status bar and select AVERAGE


B.

double-click the selection


C.

use the key combo CTRL + $


D.

click the AutoCalculate button on the toolbar


E. *

right-click on the status bar and select SUM


54.

To create a chart with the Chart Wizard, you would use which button?


A.



Download 253.19 Kb.

Share with your friends:
  1   2   3   4




The database is protected by copyright ©sckool.org 2022
send message

    Main page