Excel Sheet Format For Quiz Questions

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Minhpd.87
M
Minhpd.87
Community Contributor
Quizzes Created: 1 | Total Attempts: 78
Questions: 75 | Attempts: 78

SettingsSettingsSettings
Excel Quizzes & Trivia

The use of excel spreadsheets is one of the hard things to comprehend in the computer use. However, not everyone really uses excel, but it is widely used especially for official purposes. The quiz below tests this and more,


Questions and Answers
  • 1. 

    Trong Microsoft Excel,phuong an nao duoi day khong phai la dia chi o?

    • A.

      AS12

    • B.

      $A$12

    • C.

      $12$A

    Correct Answer
    C. $12$A
    Explanation
    The correct answer is "$12$A" because in Excel, a cell reference should start with a letter, followed by numbers. The letter represents the column and the number represents the row. In this case, "$12$A" does not follow this format as the numbers are placed before the letter.

    Rate this question:

  • 2. 

    Trong Microsoft Excel, phuong an nao duoi day la dia chi tuyet doi?

    • A.

      $A$12

    • B.

      $12$A

    • C.

      A$12$

    Correct Answer
    A. $A$12
    Explanation
    The correct answer is $A$12 because in Microsoft Excel, a cell reference with both column and row specified with dollar signs ($) is called an absolute cell reference. This means that no matter where the cell is copied or moved to, the reference will always point to the same cell. In this case, $A$12 specifies that the cell being referred to is in column A and row 12, and the dollar signs indicate that this reference is absolute.

    Rate this question:

  • 3. 

    Trong Microsoft Excel, phuomg an nao duoi day la dia chi hon hop?

    • A.

      A12$

    • B.

      $A12

    • C.

      $A$12

    Correct Answer
    B. $A12
    Explanation
    The correct answer is $A12. In Excel, a mixed reference is a combination of a relative reference and an absolute reference. In this case, the column reference is absolute ($A) while the row reference is relative (12). This means that when the formula is copied to other cells, the column reference will stay the same, but the row reference will change based on the relative position of the new cell.

    Rate this question:

  • 4. 

    Trong cong thuc cua Microsoft Excel, su dung phim nao de chuyen doi dia chi tuyet doi sang dia chi tuong doi hoac nguoc lai cho o hoac vung lua chon?

    • A.

      F2

    • B.

      F3

    • C.

      F4

    Correct Answer
    C. F4
    Explanation
    In Microsoft Excel, the F4 key is used to toggle between absolute and relative references for cells or selected range. Absolute references do not change when copied or filled, while relative references adjust based on the new location. Therefore, pressing F4 can convert an absolute address to a relative address or vice versa.

    Rate this question:

  • 5. 

    Trong Microsoft Excel, cach nao de mo mot tep Excel da co tren may tinh?

    • A.

      Ctrl十M

    • B.

      Ctrl+N

    • C.

      Ctrl+O

    Correct Answer
    C. Ctrl+O
    Explanation
    To open an existing Excel file in Microsoft Excel, you can use the shortcut Ctrl+O. This shortcut allows you to access the Open dialog box, where you can browse and select the desired Excel file from your computer. By using this shortcut, you can quickly and efficiently open Excel files without having to navigate through the menus and options in the Excel application.

    Rate this question:

  • 6. 

    Trong Microsoft Excel, cach nao de tao moi mot tep?

    • A.

      Ctrl+N

    • B.

      Ctrl + M

    • C.

      Ctrl + O

    Correct Answer
    A. Ctrl+N
    Explanation
    To create a new file in Microsoft Excel, you can use the shortcut Ctrl+N. This shortcut opens a new workbook, allowing you to start working on a new spreadsheet.

    Rate this question:

  • 7. 

    Trong Microsoft Excel, cach nao de dong mot tep?

    • A.

      Ctrl+F4

    • B.

      Shift十 F4

    • C.

      Alt+F4

    Correct Answer
    A. Ctrl+F4
    Explanation
    Ctrl+F4 is the correct answer because it is the shortcut key combination in Microsoft Excel to close a workbook or a file. Pressing Ctrl+F4 will close the active workbook or file without exiting the Excel application. This shortcut is commonly used to quickly close multiple workbooks or files when working with multiple documents simultaneously.

    Rate this question:

  • 8. 

    Trong Microsoft Excel, cach nao de thoat khoi chuang trinh?

    • A.

      Shift+F4

    • B.

      Alt+F4

    • C.

      Ctrl+F4

    Correct Answer
    B. Alt+F4
    Explanation
    Alt+F4 is the correct answer because it is a keyboard shortcut commonly used to close a program or window in Microsoft Windows. In Microsoft Excel, pressing Alt+F4 will close the Excel program, allowing the user to exit the application.

    Rate this question:

  • 9. 

    Trong Microsoft Excel, cach nao de luu tep hien tai voi ten moi?

    • A.

      F10

    • B.

      F12

    • C.

      F11

    Correct Answer
    B. F12
    Explanation
    In Microsoft Excel, pressing the F12 key allows you to save the current file with a new name. This shortcut key opens the "Save As" dialog box, where you can specify a new name and location for the file. By using F12, you can quickly save a copy of the current file without overwriting the original version.

    Rate this question:

  • 10. 

    Trong Microsoft Excel 2003,cach nao de chen bang tinh?

    • A.

      Insert/ Newsheet

    • B.

      Insert / Sheet

    • C.

      Insert / Worksheet

    Correct Answer
    C. Insert / Worksheet
    Explanation
    In Microsoft Excel 2003, to insert a new sheet or table, the correct option is "Insert / Worksheet". This option allows users to add a new worksheet within the Excel workbook.

    Rate this question:

  • 11. 

    Trong Microsoft Excel, cach nao de them mot Sheet moi?

    • A.

      Shift 十 FI1

    • B.

      Alt+F11

    • C.

      Ctrl + FI1

    Correct Answer
    A. Shift 十 FI1
    Explanation
    The correct answer is "Shift 十 FI1". This keyboard shortcut allows you to quickly add a new sheet in Microsoft Excel. By pressing Shift and then the number 10 (which is represented by 十 in this case) followed by the key F1, a new sheet will be created.

    Rate this question:

  • 12. 

    Trong Microsoft Excel, thao tac nao de doi ten bang tinh

    • A.

      Kich phai chuot tai ten bang tinh/ New/ Nhap ten mai/ Enter

    • B.

      Kich phai chuot tai ten bang tinh/ Rename/ Nhap ten moi/ Enter

    • C.

      Kich phai chuot tai ten bang tinh/ Newname/ Nhap ten moi/ Enter

    Correct Answer
    B. Kich phai chuot tai ten bang tinh/ Rename/ Nhap ten moi/ Enter
    Explanation
    To rename a worksheet in Microsoft Excel, you need to right-click on the sheet name, select "Rename," enter the new name, and press Enter.

    Rate this question:

  • 13. 

    Trong Microsoft Excel 2003,cach nao de tao duong vien cho o da chon?

    • A.

      Format/ Cells/ Colors

    • B.

      Format/ Borders/ Pattern

    • C.

      Format/ Cells/ Border

    Correct Answer
    C. Format/ Cells/ Border
    Explanation
    In Microsoft Excel 2003, to create a border for the selected cell, you need to go to the Format menu, then select Cells, and finally choose the Border option. This allows you to add borders to the selected cells in Excel 2003.

    Rate this question:

  • 14. 

    Trong M icrosoft Excel 2003,cach nao de chen mot hang phia tren hang hien hanh?

    • A.

      Insert/ New Rows

    • B.

      Insert/ Rows

    • C.

      Insert/ Row above

    Correct Answer
    B. Insert/ Rows
    Explanation
    To insert a row above the current row in Microsoft Excel 2003, you need to go to the "Insert" tab and select "Rows" from the drop-down menu. This will add a new row above the current row, shifting the existing rows down.

    Rate this question:

  • 15. 

    Trong Microsoft Excel 2003, cach nao de chen mot cot truoc cot hien hanh?

    • A.

      Insert/ Columns

    • B.

      Insert/ Column left

    • C.

      Insert/mow Columns

    Correct Answer
    A. Insert/ Columns
    Explanation
    To insert a column before the current column in Microsoft Excel 2003, the correct option is "Insert/Columns". This option allows the user to add a new column to the left of the selected column, shifting the existing columns to the right. This is a useful feature when rearranging data or adding new information in a worksheet.

    Rate this question:

  • 16. 

    Trong Microsoft Excel 2003,thao tac nao de xoa mot hang trong bang tinh?

    • A.

      Chon o tai hang can xoa/ Kich phai chuOt/ Delete/ Entire Row

    • B.

      Chon o tai hang can xoa/ Kich phai chuot/ Delete/ Row above

    • C.

      Chon o tai hang can xoa/ Kich phai chuQt/ Delete/ Row

    Correct Answer
    A. Chon o tai hang can xoa/ Kich phai chuOt/ Delete/ Entire Row
    Explanation
    In Microsoft Excel 2003, to delete a row in a spreadsheet, you need to first select the cell in the row you want to delete. Then, right-click on the selected cell and choose the "Delete" option from the menu that appears. Finally, select the "Entire Row" option to delete the entire row.

    Rate this question:

  • 17. 

    Trong Microsoft Excel 2003,thao tac nao de xoa mot cot trong bang tinh?

    • A.

      Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Column right

    • B.

      Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Entire Column

    • C.

      Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Column

    Correct Answer
    B. Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Entire Column
    Explanation
    To delete a column in Microsoft Excel 2003, you need to select the cell in the column you want to delete, right-click on it, choose "Delete," and then select "Entire Column." This will delete the entire column from the worksheet.

    Rate this question:

  • 18. 

    Trong Microsoft Excel, cach nao cho phep dua con tro ve o A1 cua bang tinh?

    • A.

      Alt+Home

    • B.

      Shift 十 Home

    • C.

      Ctrl+Home

    Correct Answer
    C. Ctrl+Home
    Explanation
    Ctrl+Home is the correct answer because it allows the user to quickly navigate to cell A1 in Microsoft Excel. By pressing Ctrl+Home, the cursor will move to the top-left cell of the worksheet, which is cell A1. This shortcut is useful when working with large spreadsheets and you want to quickly return to the starting point.

    Rate this question:

  • 19. 

    Trong Microsoft Excel, cach nao cho phep di chuyen giua cac sheet?

    • A.

      Ctrl + Page Up; Ctrl + Page Down

    • B.

      Alt + Page Up ; Alt + Page Down

    • C.

      Ctrl+Home ; Ctrl十End

    Correct Answer
    A. Ctrl + Page Up; Ctrl + Page Down
    Explanation
    The correct answer is Ctrl + Page Up; Ctrl + Page Down. This keyboard shortcut allows the user to navigate between sheets in Microsoft Excel. By pressing Ctrl + Page Up, the user can move to the previous sheet, while Ctrl + Page Down allows them to move to the next sheet. This shortcut is useful for quickly switching between different sheets within a workbook.

    Rate this question:

  • 20. 

    Trong Microsoft Excel, phim nao cho phep di chuyen con tro sang phai cua o hien hanh?

    • A.

      Tab

    • B.

      Enter

    • C.

      Backspace

    Correct Answer
    A. Tab
    Explanation
    In Microsoft Excel, the Tab key allows you to move the cursor to the right of the current cell. This is useful when you want to quickly navigate through different cells in a row or when you want to enter data in the cell to the right of the current one.

    Rate this question:

  • 21. 

    Trong Microsoft Excel, cach nao cho phep di chuyen con tro sang trai cua o

    • A.

      Ctrl + Tab

    • B.

      Alt + Tab

    • C.

      Shift + Tab

    Correct Answer
    C. Shift + Tab
    Explanation
    The correct answer is Shift + Tab. In Microsoft Excel, pressing Shift + Tab allows you to move the cursor to the left of a cell. This keyboard shortcut is useful for navigating between cells in a spreadsheet and can help improve efficiency when working with large amounts of data.

    Rate this question:

  • 22. 

    Trong Microsoft Excel, phim nao cho phep di chuyen con tro den cot dau tien cua dong hien tai?

    • A.

      Home

    • B.

      Page Down

    • C.

      Page Up

    Correct Answer
    A. Home
    Explanation
    The Home key in Microsoft Excel allows the cursor to move to the first column of the current row.

    Rate this question:

  • 23. 

    Trong Microsoft Excel, cach nao cho phep di chuyen con tro den vi tri man hinh khuat phai

    • A.

      Shift+ Page Down

    • B.

      Ctrl + Page Down

    • C.

      Alt + Page Down

    Correct Answer
    C. Alt + Page Down
    Explanation
    The correct answer is Alt + Page Down. This keyboard shortcut allows the user to move the cursor to the rightmost visible position on the screen in Microsoft Excel. Using this shortcut is helpful when working with large spreadsheets that require horizontal scrolling.

    Rate this question:

  • 24. 

    Trong Microsoft Excel, phim nao cho phep di chuyen con tro den vi tri man hinh khuat trai?

    • A.

      Ctrl + Page Up

    • B.

      Shift + Page Up

    • C.

      Alt 十 Page Up

    Correct Answer
    C. Alt 十 Page Up
    Explanation
    The correct answer is "Alt 十 Page Up". This key combination allows the cursor to move to the leftmost hidden position on the screen.

    Rate this question:

  • 25. 

    Trong Microsoft Excel, cach nao cho phep di chuyen con tro len vi tri man hinh khuat tren?

    • A.

      Page Up

    • B.

      Page Down

    • C.

      Home

    Correct Answer
    A. Page Up
    Explanation
    Page Up is the correct answer because it allows the user to move the cursor up to the previous visible screen position in Microsoft Excel. This can be useful when working with large spreadsheets that require scrolling, as it allows for quick navigation to the top of the visible area.

    Rate this question:

  • 26. 

    Trong Microsoft Excel, cach nao cho phep di chuyen con tro xuong vi tri man hinh khuat duoi?

    • A.

      Page Down

    • B.

      Home

    • C.

      Page Up

    Correct Answer
    A. Page Down
    Explanation
    Page Down là phím tắt trong Microsoft Excel cho phép di chuyển con trỏ xuống vị trí màn hình khuất dưới.

    Rate this question:

  • 27. 

    Trong Microsoft Excel 2003, thao tac nao sau day cho phep co dinh cot A va hang 1 trong khi cuon cac hang hoac cac cot khac?

    • A.

      Chon o B2/ Window/ Freeze Panes

    • B.

      Chon o B1/ Window/ Freeze Panes

    • C.

      Chon o A1/ Window/ Freeze Panes

    Correct Answer
    A. Chon o B2/ Window/ Freeze Panes
    Explanation
    In Microsoft Excel 2003, selecting cell B2 and then going to the Window menu and choosing Freeze Panes allows you to freeze column A and row 1 while scrolling through other columns or rows.

    Rate this question:

  • 28. 

    Trong Microsoft Excel 2003, thao tac nao sau day cho phep chia man hinh bang tinh thanh 4 phan?

    • A.

      Chon o B1/Window/ Split

    • B.

      Chon o A2/Window/ Split

    • C.

      Chon o A1/ Window/ Split

    Correct Answer
    C. Chon o A1/ Window/ Split
    Explanation
    The correct answer is "chon o A1/ Window/ Split". This option allows the user to split the screen into four panes, dividing the worksheet into four separate sections. This feature is useful when working with large amounts of data or when comparing different parts of the worksheet simultaneously.

    Rate this question:

  • 29. 

    Trong Microsoft Excel 2003,cach nao de sao chep dir lieu trong vung da Chon?

    • A.

      Edit/ Replace

    • B.

      Edit/ Copy

    • C.

      Edit/ Cut

    Correct Answer
    B. Edit/ Copy
    Explanation
    In Microsoft Excel 2003, to copy data within a selected range, the user can use the "Edit/Copy" option. This option allows the user to duplicate the selected data and place it in another location within the spreadsheet or in a different worksheet. By selecting the desired range, clicking on "Edit" in the menu bar, and then choosing "Copy," the user can easily duplicate the data. This option is useful when the user wants to create multiple copies of the same data or when they want to move the data to a different location without deleting the original.

    Rate this question:

  • 30. 

    Trong Microsoft Excel 2003,cach nao chi xoa noi dung cua 1 hang da chon?

    • A.

      Edit/ Delete

    • B.

      Edit/ Row/ Delete

    • C.

      Delete/ Row

    Correct Answer
    A. Edit/ Delete
    Explanation
    In Microsoft Excel 2003, to delete the content of a selected row, you can go to the Edit menu and choose the Delete option. This will remove the content of the selected row without deleting the entire row itself.

    Rate this question:

  • 31. 

    Trong Microsoft Excel, cach nao de dat con tro vao trong mot o da chon?

    • A.

      F5

    • B.

      F3

    • C.

      F2

    Correct Answer
    C. F2
    Explanation
    In Microsoft Excel, pressing the F2 key allows the user to move the cursor inside a selected cell. This is useful when editing the contents of a cell or making changes to the formula within the cell.

    Rate this question:

  • 32. 

    Trong Microsoft Excel 2003,cach nao thuc hien tron cac o da chon?

    • A.

      Format/ Cells/ Alignment/ morge Cells

    • B.

      Format/ Cells/ merge/ Cells

    • C.

      Format/ Alignment/ merge/ Cells

    Correct Answer
    A. Format/ Cells/ Alignment/ morge Cells
    Explanation
    The correct answer is "Format/ Cells/ Alignment/ merge Cells". In Microsoft Excel 2003, to merge selected cells, you need to go to the Format menu, then select Cells. In the Cells dialog box, go to the Alignment tab, and under the Text control section, click on the "Merge cells" checkbox. This will merge the selected cells into a single cell.

    Rate this question:

  • 33. 

    Trong Microsoft Excel 2003,thao tac nao canh giua noi dung trong cot B?

    • A.

      Chon cot B, chon nut Center tren thanh cong cu

    • B.

      Chon nut Center tren thanh cong cu, chon cot B

    • C.

      Chon cot B,chon Edit/ Align/ Center

    Correct Answer
    A. Chon cot B, chon nut Center tren thanh cong cu
    Explanation
    To center the content in column B in Microsoft Excel 2003, the correct operation is to select column B and then choose the Center button on the toolbar. This will align the content in column B to the center.

    Rate this question:

  • 34. 

    Trong Microsoft Excel 2003, cach nao de mo hop thoai Move or Copy?

    • A.

      Edit/ Move Or Copy Sheet...

    • B.

      Edit/ Sheet

    • C.

      Edit/ Sheet/ Move Or Copy

    Correct Answer
    A. Edit/ Move Or Copy Sheet...
    Explanation
    In Microsoft Excel 2003, to open the Move or Copy dialog box, you can go to the "Edit" menu and select "Move or Copy Sheet..." option. This option allows you to move or copy a sheet to a different location within the same workbook or to a different workbook.

    Rate this question:

  • 35. 

    Trong Microsoft Excel 2003, cach nao de lap lai hang tieu de tren cac trang?

    • A.

      File/ Page Setup/ Page

    • B.

      File/ Page Setup/ Sheet

    • C.

      File/ Page Setup/ Print area

    Correct Answer
    B. File/ Page Setup/ Sheet
    Explanation
    In Microsoft Excel 2003, to repeat the header row on each page, you would go to "File/ Page Setup/ Sheet". This option allows you to specify which rows or columns should be repeated on each printed page. By selecting the header row in this setting, it will be automatically repeated on every page when printing the spreadsheet.

    Rate this question:

  • 36. 

    Trong Microsoft Excel 2003,cach nao de ngat trang tai vi tri hien hanh?

    • A.

      Edit/ Page Break

    • B.

      Insert/ Page Break

    • C.

      View/ Page Break

    Correct Answer
    B. Insert/ Page Break
    Explanation
    In Microsoft Excel 2003, to insert a page break at the current position, the correct option is "Insert/ Page Break". This option allows the user to manually insert a page break in the worksheet, which helps in controlling the printing of the document. By inserting a page break, the user can specify where the content should start on a new page, ensuring better organization and presentation of the data when printing.

    Rate this question:

  • 37. 

    Trong Microsoft Excel 2003,tai hop thoai Move Or Copy, thao tac nao de sao chep mot bang tinh?

    • A.

      Chon muc Move

    • B.

      Chon muc Copy

    • C.

      Chon muc Create a copy

    Correct Answer
    C. Chon muc Create a copy
    Explanation
    In Microsoft Excel 2003, to copy a worksheet, you need to select the option "Create a copy" in the Move or Copy dialog box. This option allows you to create a duplicate of the worksheet in the same workbook or in a different workbook. By choosing this option, you can easily make a copy of the worksheet without affecting the original one.

    Rate this question:

  • 38. 

    Trong Microsoft Excel 2003,cach nao de sap xep du lieu theo thur tu tang dan?

    • A.

      Data/ Sort by / Descending

    • B.

      Data/ Sort/ Descending

    • C.

      Data/ Sort/ Ascending

    Correct Answer
    C. Data/ Sort/ Ascending
    Explanation
    To sort data in ascending order in Microsoft Excel 2003, you need to go to the "Data" tab, then select "Sort" and finally choose "Ascending". This will arrange the data in increasing order based on the selected column.

    Rate this question:

  • 39. 

    Trong Microsoft Excel 2003, cach nao de sap xep du: lieu theo thur ty giam dan?

    • A.

      Data/ Sort/ Descending

    • B.

      Data/ Sort/ Ascending

    • C.

      Data/ Sort by/ Descending

    Correct Answer
    A. Data/ Sort/ Descending
    Explanation
    In Microsoft Excel 2003, to sort data in descending order, you can go to the "Data" tab and select "Sort". From there, choose the "Descending" option. This will arrange the data in reverse order, from highest to lowest.

    Rate this question:

  • 40. 

    Trong Microsoft Excel 2003, cach nao de loc du* lieu tu dong?

    • A.

      Data/ Filter/ Advance Fitter

    • B.

      Data/ Auto/ Filter

    • C.

      Data/ Filter/ AutoFilter

    Correct Answer
    C. Data/ Filter/ AutoFilter
    Explanation
    In Microsoft Excel 2003, to automatically filter data, you can use the option "Data/Filter/AutoFilter". This feature allows you to quickly filter data based on specific criteria, making it easier to analyze and work with large datasets.

    Rate this question:

  • 41. 

    Trong Microsoft Excel 2003, cach nao cho phep loc co dieu kien trong vung tieu chuan?

    • A.

      Data/ Filter/ Advance

    • B.

      Windows/ Filter/ Advance Filter

    • C.

      Data/ Filter/ Advance Filter

    Correct Answer
    C. Data/ Filter/ Advance Filter
    Explanation
    In Microsoft Excel 2003, the option to filter with conditions in a standard range is available under the "Data" tab. By selecting "Filter" and then "Advance Filter," users can apply specific criteria to filter the data within the selected range.

    Rate this question:

  • 42. 

    Trong Microsoft Excel 2003, chon Data/ Filter de thuc hien cong viec gi?

    • A.

      Tong hop du"lieu

    • B.

      Trich loc du lieu

    • C.

      Sap xep du lieu

    Correct Answer
    B. Trich loc du lieu
    Explanation
    In Microsoft Excel 2003, selecting Data/Filter allows you to extract or filter specific data from a larger dataset. This feature enables you to display only the data that meets certain criteria or conditions, making it easier to analyze and work with the relevant information. By selecting this option, you can narrow down the dataset and focus on the specific data that you need for your task or analysis.

    Rate this question:

  • 43. 

    Trong Microsoft Excel 2003,cach nao cho phep tao bieu do cho vung gia tri duoc chon?

    • A.

      Insert/ Bar Chart

    • B.

      Insert/ Chart

    • C.

      Insert/ Column Chart

    Correct Answer
    B. Insert/ Chart
    Explanation
    In Microsoft Excel 2003, the option "Insert/ Chart" allows users to create a chart for the selected range of values. This option provides a variety of chart types, including bar charts and column charts, to visualize and analyze data effectively.

    Rate this question:

  • 44. 

    Trong Microsoft Excel 2003, cach nao khong tao duoc bieu do cho vung gia tri duoc chon?

    • A.

      Chon bieu tuong Chart Wizard tren thanh cong cu

    • B.

      Insert/ Chart Option

    • C.

      Insert/ Chart

    Correct Answer
    B. Insert/ Chart Option
    Explanation
    The correct answer is "Insert/ Chart Option". In Microsoft Excel 2003, selecting "Insert/ Chart Option" does not create a chart for the selected range of values. This option may be used for other chart-related actions or settings, but it does not directly create a chart.

    Rate this question:

  • 45. 

    Trong Microsoft Excel 2003, hop thoai Chart Options cho phep dua cac thong tin nao sau day cho bieu do?

    • A.

      Hien thi hay khong hien thi cac gia tri tren bieu do

    • B.

      Bao gom ca 2 phiromg an con lai

    • C.

      Tieu de cua bieu do, tieu de cac true, cac kieu dirorng ludi trong bieu do

    Correct Answer
    B. Bao gom ca 2 phiromg an con lai
    Explanation
    The Chart Options dialog box in Microsoft Excel 2003 allows you to include both the display or non-display of values on the chart and the title of the chart, as well as the titles of the axes and the type of data labels in the chart.

    Rate this question:

  • 46. 

    Trong Microsoft Excel 2003, khi ve bieu do bang cong cu Chart Wizard, the Data Range cho phep lam gi?

    • A.

      Gan nhan cho vung du* lieu

    • B.

      Thay doi vung du lieu ve bieu do

    • C.

      Xoa du lieu

    Correct Answer
    B. Thay doi vung du lieu ve bieu do
    Explanation
    The correct answer is "Thay doi vung du lieu ve bieu do" which means "Change the data range for the chart" in English. This option allows the user to modify the range of data that is used to create the chart. By selecting this option, the user can choose a different set of data to be plotted on the chart, allowing for customization and flexibility in visualizing the data.

    Rate this question:

  • 47. 

    Trong Microsoft Excel 2003,thao tac nao cho phep thay doi lai kieu bieu do?

    • A.

      Kich chuot phai vao duong vien cua bieu do/ Chart Type/ Chon lai kieu/ OK

    • B.

      Kich chuot phai vao duong vien cua bieu do/ Chart Window/ chon lai kieu/OK

    • C.

      Kicli chuot phai vao duang vien cua bieu do/ Chart Options/ Chon lai kieu/ OK

    Correct Answer
    A. Kich chuot phai vao duong vien cua bieu do/ Chart Type/ Chon lai kieu/ OK
    Explanation
    In Microsoft Excel 2003, to change the chart type, you need to right-click on the border of the chart, select "Chart Type," choose the desired type, and click "OK." This action allows you to modify the chart type and customize it according to your needs.

    Rate this question:

  • 48. 

    Trong Microsoft Excel, bieu do loai nao thich hop cho viec hien thi gia tri dudi dang % (percentage)?

    • A.

      Pie

    • B.

      Column

    • C.

      Line

    Correct Answer
    A. Pie
    Explanation
    A pie chart is the most suitable type of chart for displaying values in percentage format. In a pie chart, the whole circle represents 100% and each slice represents a proportionate percentage of the whole. This makes it easy to visualize the distribution of percentages and compare different categories.

    Rate this question:

  • 49. 

    Trong Microsoft Excel 2003,cach nao cho phep chon font chu cho tieu de cua bieu do?

    • A.

      Kich chuot phai vao vung tieu de/ Font Chart Tilte/ Font

    • B.

      Kich chuot phai vao vung tieu de/ Format Font/ Font

    • C.

      Kich chuot phai vao vung tieu de/ Format Chart Tilte/ Font

    Correct Answer
    C. Kich chuot phai vao vung tieu de/ Format Chart Tilte/ Font
    Explanation
    In Microsoft Excel 2003, to select the font for the chart title, you need to right-click on the chart title, select "Format Chart Title," and then choose the desired font.

    Rate this question:

  • 50. 

    Trong Microsoft Excel 2003,cong cu nao cho phep thay doi mau sac cho vung duoc chon?

    • A.

      Cong cu Fill Color tren thanh dinh dang

    • B.

      Cong cu Line Color tren thanh dinh dang

    • C.

      Cong cu Font Color tren thanh dinh dang

    Correct Answer
    A. Cong cu Fill Color tren thanh dinh dang
    Explanation
    The correct answer is "Cong cu Fill Color tren thanh dinh dang" (The Fill Color tool in the Formatting toolbar). This tool allows users to change the color of the selected range in Microsoft Excel 2003. It is used to fill cells, shapes, or objects with a specific color.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 05, 2014
    Quiz Created by
    Minhpd.87
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.