EXCEL GYAN

1. Is it possible to insert an image from a file into an Excel spreadsheet?

Yes

No

2. Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?

Yes

No

Submit

4. A macro is a recording of a series of steps that completes a task or group of tasks that can be "played back" later when needed.

True

False

A macro is a "mini program" the user creates in Excel by actually going through the steps desired while Excel records the keystrokes and commands typed.

Explanation

A macro is a "mini program" the user creates in Excel by actually going through the steps desired while Excel records the keystrokes and commands typed.

5. What appears in a cell when a column is not wide enough for its numerical contents?

??????????

##########

>>>>>>>>>>

!!!!!!!!!!

####### appear if the cell is too narrow to display the numerical contents.
To widen the column exactly enough to hold the longest entry in it: Double-click the divider between the column headers or choose Home→Cells→Format→AutoFit Column Width.

To widen the column manually: Drag the divider between the column headers.

Explanation

####### appear if the cell is too narrow to display the numerical contents.
To widen the column exactly enough to hold the longest entry in it: Double-click the divider between the column headers or choose Home→Cells→Format→AutoFit Column Width.

To widen the column manually: Drag the divider between the column headers.

6. Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?

7. Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?

#

%

&

$

8. Which feature in Excel allows you to view two spreadsheets in one window?

Freeze panes

Split

View side by side

9. What function would display the highest sales amount in a column?

Min()

Avg()

Max()

Most()

Sum()

10. When you enter a formula in Excel, what sign must go in front of the formula?

>

#

=

!

When entering formulas, you need to put an equals (=) sign in front. Otherwise, the formula will merely be text in a cell.

Explanation

When entering formulas, you need to put an equals (=) sign in front. Otherwise, the formula will merely be text in a cell.

11. Which of the following tasks can be performed with Excel?

Create a spreadsheet

Create a chart

Summarise numerical data

All of the above

12. Which of the following is an absolute cell reference?

P72

G$9

$K356

$F$8

13. 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.

Press ALT and single-click anywhere in the column.

14. Text inside a cell is aligned

Left

Right

Center

Bottom

15. What type of operation is being preformed in the formula =A4*B5

Addition

Subtraction

Division

Percentage

Multiplication

16. What will be the formula in the cell B3 if you want to calculate the profit?

=A1-A2

=B2-B1

=B1-B2

None of the above

Profit is equal to Revenue(B1) - Expense(B2). There the formula in B3 should be =B1 - B2.

Explanation

Profit is equal to Revenue(B1) - Expense(B2). There the formula in B3 should be =B1 - B2.

17. The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

A1-J15

A1.J15

A1;J15

A1:J15

18. The format for an IF statement is:

=SUM(condition,x,y)

=IF(condition,x,y)

=(condition,x,y)

19. True or False: Headers and footers only apply to a specific worksheet not the entire workbook

True

False

Headers and footers typically appear on every page of a report. In Excel 2010, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to identify the document and to display the page numbers. Unless you specify otherwise, Excel does not automatically add either a header or footer to a new workbook.

Explanation

Headers and footers typically appear on every page of a report. In Excel 2010, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to identify the document and to display the page numbers. Unless you specify otherwise, Excel does not automatically add either a header or footer to a new workbook.

Submit

21. Number of rows in a spreadsheet

256

255

65,565

50,000

22. A Formula and a function are the same thing.

True

False

23. How would Excel display this value =ROUND(1.567) in the cell?

1

2

1.57

1.6

24. How would the cell reference $F$4 be described?

Mixed reference

Absolute reference

Relative reference

Additional reference

Money reference

25. A_________ is a built in mathematical formula included in excel.

Function

Cell

Formula

Range

26. By default how many worksheets are in a workbook?

1

2

3

4

27. Which function would you use to find the largest number of a selected range?

MAXIMUM

MAX

LARGE

LARGEST

28. Which feature in Excel allows you to view two spreadsheets in one window?

Freeze panes

Split

View side by side

Mirror

29. Which of the following is an mixed cell reference with a fixed column address?

P72

G$9

$K356

$F$8

30. What does the TRUNC function do?

Formats data

Indents data

Adds numbers

Removes the decimal part of the number

31. A chart that occupies its own worksheet

Embedded chart

Chart sheet

Stand alone chart

32. A key that identifies each of the data series in a chart.

Key

Map

Legend

33. Which orientation is taller than it is wide?

Landscape

Portrait

34. The Chart Tools commands are found in these three tabs?

Design, Shape, Layout

Layout, Format, Type

Design, Layout, Format

Styles, Shapes, Effects

35. What does a hyperlink do?

Adds another argument

Displays a website

Formats worksheet

Hides worksheets

36. Which function enters the current date?

Now()

Days()

DDYYMM

TODAY()

37. How can you start Edit mode to edit a formula?

Tools

Format

F4

F2 or double-click cell

Find and replace

38. Which of the following is a relative cell reference?

P72

G$9

$K356

$F$8

39. What is a pivot table?

A report

An advanced filter

A filter

Vlookup

40. A graphic that allows you to compare and contrast data in a visual format.

Plot

Legend

Chart

41. Which of the following is mixed cell reference with a fixed row address?

P72

G$9

$K356

$F$8

42. Values in a cell are aligned at the

Left

Right

Center

Bottom

43. .................is a collection of pages in a workbook

Spreadsheet

Worksheet

Spreadbook

Sheet

44. What is the keyboard shortcut command to move the mouse pointer to cell A1

Control + Home

Control + F4 key

Name box

Control + A1

Control + Tab key

45. What is the keyboard shortcut to display or hide formulas?

Control + F4 key

Control + ~

Control + K

Control + P

Control +F

46. How many data series can be used in a pie chart?

0

As many as you want.

1

7

A pie chart would be meaningless with more than one data series, therefore Excel will not even produce a pie chart if you try to use more than one data series.

Explanation

A pie chart would be meaningless with more than one data series, therefore Excel will not even produce a pie chart if you try to use more than one data series.

47. A document inside excel is called a

A worksheet

A workbook

A page

An object

48. Which formula will automatically change a decimal value of .5 or greater up to the next highest whole number value?

ROUND

ROUNDUP

ROUNDDOWN

RAND

49. Removing the contents of a cell is known as ____ a cell.

Clearing

Emptying

Editing

Deleting

50. How do you spell check an Excel worksheet?

Under the Tools menu, click Spelling.

Press F7.

Click the button with ABC Check Mark icon.

Any of the above will perform a spell check.

Excel Gyan

1. Is it possible to insert an image from a file into an Excel spreadsheet?

2.

What first name or nickname would you like us to use?

2. Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?

3. If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?

4. A macro is a recording of a series of steps that completes a task or group of tasks that can be "played back" later when needed.

5. What appears in a cell when a column is not wide enough for its numerical contents?

6. Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?

7. Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?

8. Which feature in Excel allows you to view two spreadsheets in one window?

9. What function would display the highest sales amount in a column?

10. When you enter a formula in Excel, what sign must go in front of the formula?

11. Which of the following tasks can be performed with Excel?

12. Which of the following is an absolute cell reference?

13. How do you change column width to fit the contents?

14. Text inside a cell is aligned

15. What type of operation is being preformed in the formula =A4*B5

16. What will be the formula in the cell B3 if you want to calculate the profit?

17. The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

18. The format for an IF statement is:

19. True or False: Headers and footers only apply to a specific worksheet not the entire workbook

20. A group of worksheet cells is called a _________.

21. Number of rows in a spreadsheet

22. A Formula and a function are the same thing.

23. How would Excel display this value =ROUND(1.567) in the cell?

24. How would the cell reference $F$4 be described?

25. A_________ is a built in mathematical formula included in excel.

26. By default how many worksheets are in a workbook?

27. Which function would you use to find the largest number of a selected range?

28. Which feature in Excel allows you to view two spreadsheets in one window?

29. Which of the following is an mixed cell reference with a fixed column address?

30. What does the TRUNC function do?

31. A chart that occupies its own worksheet

32. A key that identifies each of the data series in a chart.

33. Which orientation is taller than it is wide?

34. The Chart Tools commands are found in these three tabs?

35. What does a hyperlink do?

36. Which function enters the current date?

37. How can you start Edit mode to edit a formula?

38. Which of the following is a relative cell reference?

39. What is a pivot table?

40. A graphic that allows you to compare and contrast data in a visual format.

41. Which of the following is mixed cell reference with a fixed row address?

42. Values in a cell are aligned at the

43. .................is a collection of pages in a workbook

44. What is the keyboard shortcut command to move the mouse pointer to cell A1

45. What is the keyboard shortcut to display or hide formulas?

46. How many data series can be used in a pie chart?

47. A document inside excel is called a

48. Which formula will automatically change a decimal value of .5 or greater up to the next highest whole number value?

49. Removing the contents of a cell is known as ____ a cell.

50. How do you spell check an Excel worksheet?

3. If cells:
A1=90
A2=85
A3=80
A4=75
A5=75
What will be your formula if you are going to get the total?