Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams
Computer Awareness Questions and Quiz for Banking, IBPS, RRB, RBI, SBI, NABARD examinations of 2020-2021. Computer Awareness MCQs for Competitive Exams. GKToday Computer Awareness for IBPS PO, IBPS Clerk, Bank PO, Bank Clerk and other entrance / competitive examinations.
81. What is the default file extension of MS Excel files?
[A] .acs
[B] .exc
[C] .exe
[D] .xls
Show Answer
Correct Answer: D [.xls]
Notes:
XLS file extension icon is the default MS Excel file extension. XLS is a file extension for a spreadsheet file format created by Microsoft for use with Microsoft Excel.
82. What is the use of Shift + F11 in MS Excel?
[A] Deletes the workbook
[B] Deletes the current sheet
[C] Inserts a new sheet
[D] Inserts a new row
Show Answer
Correct Answer: C [Inserts a new sheet]
Notes:
When Shift and F11 key is pressed together, a new sheet is inserted in MS Excel. It is a quick way to add a new sheet.
83. Which of these is a shortcut to add a border to the selected cell in MS Excel?
[A] CTRL + Shift + /
[B] CTRL + Shift + &
[C] ALT + Shift + /
[D] ALT + Shift + B
Show Answer
Correct Answer: B [CTRL + Shift + &]
Notes:
CTRL + Shift + & is used to add a border to the selected cell in MS Excel. It is a shortcut to add border to the active cell.
84. How can all the text in all the slides be selected in MS PowerPoint?
[A] By clicking Ctrl + A in Slides view
[B] By clicking Ctrl + A in Outline view
[C] By clicking Ctrl + O in Slides view
[D] By clicking Ctrl + S in Outline view
Show Answer
Correct Answer: B [By clicking Ctrl + A in Outline view]
Notes:
All the text in all the slides can be selected in MS PowerPoint by clicking Ctrl + A in Outline view. All the slides can be selected by clicking Ctrl + A in Slides view.
85. Which of these datatypes in MS Access allows alphabets, numbers and special characters?
[A] Short Text
[B] Currency
[C] Date
[D] Autonumber
Show Answer
Correct Answer: A [Short Text]
Notes:
Short text is a datatype which includes Text or combinations of text and numbers, including numbers that do not require calculating.
86. Under which menu there is an option to export data in MS Access?
[A] External Data
[B] Database tools
[C] Home
[D] Create
Show Answer
Correct Answer: A [External Data]
Notes:
Data can be exported the data from table, query, form, and report objects etc. The option to export the data in MS Access is given under the External Data tab.
87. Which function in MS Access gives the number of time intervals between two specified dates?
[A] DateInter()
[B] DateSub()
[C] DateDiff()
[D] DaysBetween()
Show Answer
Correct Answer: C [DateDiff()]
Notes:
The DateDiff() Function is another very popular date/time function. The DateDiff Function returns a Variant (long), specifying the number of time intervals between two specified dates.
88. Which of these MS Access functions return the current user?
[A] IsUser()
[B] AccUser()
[C] User()
[D] CurrentUser()
Show Answer
Correct Answer: D [CurrentUser()]
Notes:
CurrentUser() is the MS Access function which return the current user. This function returns the name of the current database user.
89. What is MS Access?
[A] A RDBMS
[B] An OODBMS
[C] An ORDBMS
[D] A Network Database Model
Show Answer
Correct Answer: A [A RDBMS]
Notes:
Microsoft Access is a low cost relational database management system (RDBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
90. What do we call the columns of a table in Microsoft Access?
[A] Rows
[B] Records
[C] Fields
[D] Category
Show Answer
Correct Answer: C [Fields]
Notes:
A field in MS Access is a piece of information related to a single person or thing. Related fields are grouped together to form a record.
[contact-form-7 id="141158" title="Contact form 1"]
